﻿CREATE TABLE [dbo].[Customer_Remind] (
    [Id]         INT           IDENTITY (1, 1) NOT FOR REPLICATION NOT NULL,
    [CustomerId] NVARCHAR (50) NULL,
    [RemindDate] DATETIME      NULL,
    [UserName]   NVARCHAR (50) NULL,
    [UpTime]     DATETIME      NULL,
    CONSTRAINT [PK_Customer_Remind] PRIMARY KEY CLUSTERED ([Id] ASC) WITH (FILLFACTOR = 90)
);


GO
CREATE NONCLUSTERED INDEX [IX_Customer_Remind_UserName]
    ON [dbo].[Customer_Remind]([UserName] ASC) WITH (FILLFACTOR = 90);


GO
CREATE NONCLUSTERED INDEX [IX_Customer_Remind_RemindDate]
    ON [dbo].[Customer_Remind]([RemindDate] ASC) WITH (FILLFACTOR = 90);


GO
CREATE NONCLUSTERED INDEX [IX_Customer_Remind_CustomerId]
    ON [dbo].[Customer_Remind]([CustomerId] ASC) WITH (FILLFACTOR = 90);

